/*
Navicat MySQL Data Transfer

Source Server         : mysql80
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : his_db

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2020-07-19 21:26:26
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('1', 'User', '/user', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('2', 'Department', '/department', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('3', 'regiType', '/regiType', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('4', 'disease', '/disease', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('5', 'non_drug', '/non_drug', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('6', 'doctor_duty', '/doctor_duty', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('7', '/Registration', '/registration', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('8', '/Fee', '/fee', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('9', '/Refund', '/refund', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0'), ('10', '/RemoveDiag', '/removeDiag', null, '2020-07-19 21:21:01', '2020-07-19 21:21:01', '0');
COMMIT;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', '系统管理员', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0'), ('2', '挂号收费员', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0'), ('3', '门诊医生', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0'), ('4', '医技医生', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0'), ('5', '药房管理员', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0'), ('6', '财务管理员', '2020-07-19 18:30:09', '2020-07-19 18:30:09', '0');
COMMIT;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO `role_menu` VALUES ('1', '1', '1', null, null, null), ('2', '1', '2', null, null, null), ('3', '1', '3', null, null, null), ('4', '1', '4', null, null, null), ('5', '1', '5', null, null, null), ('6', '1', '6', null, null, null), ('7', '2', '7', null, null, null), ('8', '2', '8', null, null, null), ('9', '2', '9', null, null, null), ('10', '2', '10', null, null, null), ('11', '3', null, null, null, null), ('12', null, null, null, null, null), ('13', null, null, null, null, null), ('14', null, null, null, null, null), ('15', null, null, null, null, null), ('16', null, null, null, null, null), ('17', null, null, null, null, null);
COMMIT;
